Simple Process

1. Find a schedule you like and put it into a spreadsheet to modify it to your liking. I
will follow up on this process after you are familiar with the create process.  Save a copy
of the original in case you make an error.

2.  Paste the schedule into the schedule spreadsheet under the master schedule tab.  This is
used as a base schedule and for future use.

3.  Copy this to the new schedule tab.  You will see 2 columns with the new schedule matchups
and a table that changes the matchups. 

4.  The first step I did was to create the team number change table on the right of the sheet
randomizing numbers 1-10 and 11-20.  You only need to do this once but if you want to you
can change the numbers as long as you do not duplicate entries.  1-10 must still be 1-10 but 
can be any order.  The right column is the new random number.

5.  Copy the schedule from the master to the new schedule col A-D.  

6.  The next step was to create the columns to change the schedule home and away matchups.  
This was simply a lookup on the table I created.  You can look at any cell and see the formula.

7.  After the new matchup columns were created all I did was copy the column and paste special 
over the last 2 columns of the schedule in A-D. This will change the new team number columns
for the next time you need to create a new schedule with different matchups.

8  The last step is to simply copy the new schedule to the SchdGen spreadsheet.  This could have
been placed into this spreadsheet but I was looking at making this a system with the schedule
file being separate incase you have multiple schedules as templates.  You must just copy the columns
from the schedule including the first line.  Paste this on line 1 in SchdGen and you will see 
the lsdl lines.  Go to Data:Sort and it is setup to sort by Day and Home Team.  If this gets 
messed up just redo the sort scdate first order and schome last.  Copy the data into a blank
schedule file.  I take the original copy delete the games and paste the new games into the
.lsdl file.  Any lsdl file will work, it just takes more work modifying one that does not have
similar header information.

9.  Thats it.  Sounds difficult but is not.




Side Note:  I created the SchdGen for use in the project I am doing converting over 300 minor league 
files into the OOTP format.  That spreadsheet is very much different than this one. So I made this 
one simple to do one job - put an inputted schedule into OOTP format.  This spreadsheet can be used 
to take the 4 columns from another spreadsheet, or text file. It is also neat that if you created a
schedule on paper you could also just enter the data into the columns and it will also work to create
a schedule.  This works great for small schedules or if you creating a schedule that is not in OOTP 
format to start.

Once you are familiar with this I can send you a sample of how I am converting text files and creating
the OOTP lsdl files for the minor league conversion program.

James